package com.tql.pandian.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.tql.pandian.entity.ProlossDetialDto;
import com.tql.pandian.entity.TqlStapProloss;
import com.tql.pandian.entity.TqlStapProlossDiagnosisInfo;
import com.tql.pandian.entity.TqlStapProlossItem;
import com.tql.pandian.vo.TopCateStapProlossVO;
import com.tql.pandian.vo.TqlStapProlossItemVO;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
* @author Administrator
* @description 针对表【tql_stap_proloss】的数据库操作Mapper
* @createDate 2024-02-23 16:51:14
* @Entity generator.domain.TqlStapProloss
*/
public interface TqlStapProlossMapper extends BaseMapper<TqlStapProloss> {

    List<TqlStapProlossItemVO> selectStapInChange(@Param("tableName") String tableName, @Param("deptCode") String deptCode, @Param("stapCode") String stapCode, @Param("std") Long std, @Param("etd") Long etd);

    List<TqlStapProlossItemVO> selectStapInChangeData(@Param("tableName") String tableName, @Param("deptCodes") List<String> deptCodes, @Param("stapCodes") List<String> stapCodes, @Param("paramDate") String paramDate);

    TqlStapProlossItemVO getOpening(Map<String, Object> params);

    TqlStapProlossItemVO endOfPeriod(Map<String, Object> params);

    List<TqlStapProloss> selectListByStapType(Map<String, Object> params);
    List<TqlStapProloss> stapProlossAnalysDetail(Long[] arr);
    String getStatTypeName(@Param("stapTypeCode") String stapType);

    String getDeptName(@Param("deptCode") String deptCode);

    String getStapName(@Param("stapCode") String stapCode);

    List<TqlStapProlossItem> listByParams(Map<String, Object> params);

    public List<TqlStapProlossDiagnosisInfo> stapProlossAnalys(String pandianCode);


    ProlossDetialDto findStapProlossDetailByPid(Long id);

    ProlossDetialDto getProlossDetialDto(Map<String, Object> params);

    TqlStapProloss selectStapProlossById(Long id);
}




